//
//  HistoryTableViewController.swift
//  ZTC_Final
//
//  Created by xy Man on 2022/5/27.
//

import UIKit

class HistoryTableViewController: UITableViewController {

    var username:String = ""
    var nowSelectedId:Int = -1
    var nowSelctedTime:String = ""
    override func viewDidLoad() {
        super.viewDidLoad()
        let xib = UINib(nibName: "HistoryTableViewCell", bundle: nil)
        tableView.register(xib, forCellReuseIdentifier: "historyCell")
        tableView.rowHeight = 187
        // Uncomment the following line to preserve selection between presentations
        // self.clearsSelectionOnViewWillAppear = false

        // Uncomment the following line to display an Edit button in the navigation bar for this view controller.
        // self.navigationItem.rightBarButtonItem = self.editButtonItem
    }

    // MARK: - Table view data source

    override func numberOfSections(in tableView: UITableView) -> Int {
        // #warning Incomplete implementation, return the number of sections
        return 1
    }

    override func tableView(_ tableView: UITableView, numberOfRowsInSection section: Int) -> Int {
        // #warning Incomplete implementation, return the number of rows
        
        let numOforders = getQueryData(sql: "SELECT COUNT(*) FROM history WHERE username='\(username)';")
        if numOforders == nil{
            return 0
        }
        return numOforders![0]["COUNT(*)"] as! Int
    }
    
    func getQueryData(sql:String)->[[String : AnyObject]]?{
        let sqlite = SQLiteManager.sharedInstance
        if !sqlite.openDB(){return []}
        let queryres = sqlite.execQuerySQL(sql: sql)
        sqlite.closeDB()
        return queryres
    }
    
    func doNonSql(sql:String)->Void{
        let sqlite = SQLiteManager.sharedInstance
        if !sqlite.openDB(){return}
        if !sqlite.execNoneQuerySQL(sql: sql){return}
        sqlite.closeDB()
    }

    
    override func tableView(_ tableView: UITableView, cellForRowAt indexPath: IndexPath) -> UITableViewCell {
        let cell = tableView.dequeueReusableCell(withIdentifier: "historyCell", for: indexPath) as! HistoryTableViewCell

        // Configure the cell...
        let queryres = getQueryData(sql: "SELECT * FROM history WHERE username='\(username)';")
        
        if queryres!.count != 0{
            let current_id = queryres![indexPath.row]["id"] as! Int
            cell.orderID.text = "\(current_id)"
            let current_totalprice = queryres![indexPath.row]["totalprice"] as! Double
            cell.totalPrice.text = "\(current_totalprice)元"
            let time = queryres![indexPath.row]["time"] as! String
            cell.dealTime.text = time
            let bookname = queryres![indexPath.row]["bookname"] as! String
            cell.bookname.text = bookname
            let booknum = queryres![indexPath.row]["number"] as! Int
            cell.booknum.text = "\(booknum)本"
        }
        return cell
    }
    
    override func viewWillAppear(_ animated: Bool) {
        tableView.reloadData()
    }
    
    override func tableView(_ tableView: UITableView, didSelectRowAt indexPath: IndexPath) {
        let queryres = getQueryData(sql: "SELECT * FROM history WHERE username='\(username)';")
        nowSelectedId = queryres![indexPath.row]["id"] as! Int
        nowSelctedTime = queryres![indexPath.row]["time"] as! String
        performSegue(withIdentifier: "his2hisdetail", sender: nil)
    }

    /*
    // Override to support conditional editing of the table view.
    override func tableView(_ tableView: UITableView, canEditRowAt indexPath: IndexPath) -> Bool {
        // Return false if you do not want the specified item to be editable.
        return true
    }
    */

    /*
    // Override to support editing the table view.
    override func tableView(_ tableView: UITableView, commit editingStyle: UITableViewCell.EditingStyle, forRowAt indexPath: IndexPath) {
        if editingStyle == .delete {
            // Delete the row from the data source
            tableView.deleteRows(at: [indexPath], with: .fade)
        } else if editingStyle == .insert {
            // Create a new instance of the appropriate class, insert it into the array, and add a new row to the table view
        }    
    }
    */

    /*
    // Override to support rearranging the table view.
    override func tableView(_ tableView: UITableView, moveRowAt fromIndexPath: IndexPath, to: IndexPath) {

    }
    */

    /*
    // Override to support conditional rearranging of the table view.
    override func tableView(_ tableView: UITableView, canMoveRowAt indexPath: IndexPath) -> Bool {
        // Return false if you do not want the item to be re-orderable.
        return true
    }
    */

    
    // MARK: - Navigation

    // In a storyboard-based application, you will often want to do a little preparation before navigation
    override func prepare(for segue: UIStoryboardSegue, sender: Any?) {
        // Get the new view controller using segue.destination.
        // Pass the selected object to the new view controller.
        let detail = segue.destination as! HistoryDetailTableViewController
        detail.username = username
        detail.id = nowSelectedId
        detail.time = nowSelctedTime
    }
    

}
